Overview

Dataset info

Number of variables53
Number of observations19498
Missing cells6709 (0.6%)
Duplicate rows0 (0.0%)
Total size in memory7.9 MiB
Average record size in memory424.0 B

Variables types

Numeric9
Categorical34
Boolean5
Date0
URL0
Text (Unique)0
Rejected5
Unsupported0

Warnings

Account_Created_Date has a high cardinality: 903 distinct values Warning
Account_Name has a high cardinality: 1840 distinct values Warning
Actual_Delivery_Date has constant value "NaT" Rejected
ASP has 316 (1.6%) zeros Zeros
ASP has 3293 (16.9%) missing values Missing
ASP_(converted) is highly skewed (γ1 = 74.73154913) Skewed
ASP_(converted) has 315 (1.6%) zeros Zeros
ASP_(converted) has 3293 (16.9%) missing values Missing
ASP_(converted)_Currency has constant value "USD" Rejected
Billing_Country has a high cardinality: 83 distinct values Warning
Last_Activity has constant value "NaT" Rejected
Last_Modified_By has a high cardinality: 63 distinct values Warning
Last_Modified_Date has a high cardinality: 751 distinct values Warning
Month has a high cardinality: 60 distinct values Warning
Opportunity_Created_Date has a high cardinality: 1203 distinct values Warning
Opportunity_Name has a high cardinality: 11408 distinct values Warning
Opportunity_Owner has a high cardinality: 58 distinct values Warning
Planned_Delivery_End_Date has a high cardinality: 1214 distinct values Warning
Planned_Delivery_Start_Date has a high cardinality: 1193 distinct values Warning
Price has a high cardinality: 58 distinct values Warning
Prod_Category_A has constant value "Prod_Category_A_None" Rejected
Product_Family has a high cardinality: 247 distinct values Warning
Product_Name has a high cardinality: 506 distinct values Warning
Quote_Expiry_Date has a high cardinality: 1124 distinct values Warning
Sales_Contract_No has a high cardinality: 6065 distinct values Warning
Territory has a high cardinality: 79 distinct values Warning
Total_Amount is highly skewed (γ1 = 40.71457842) Skewed
Total_Amount_Currency is a recoding of ASP_CurrencyRejected
Total_Taxable_Amount is highly skewed (γ1 = 30.86984245) Skewed
Total_Taxable_Amount has 1090 (5.6%) zeros Zeros
TRF is highly skewed (γ1 = 38.14278497) Skewed
TRF has 13677 (70.1%) zeros Zeros

Variables

Account_Created_Date
Categorical

Distinct count903
Unique (%)4.6%
Missing (%)0.0%
Missing (n)0
7/27/2013
3061
4/20/2015
3014
9/23/2013
 
610
Other values (900)
12813
ValueCountFrequency (%) 
7/27/2013 3061 15.7%
 
4/20/2015 3014 15.5%
 
9/23/2013 610 3.1%
 
9/19/2014 397 2.0%
 
12/21/2015 365 1.9%
 
8/22/2013 327 1.7%
 
7/28/2013 307 1.6%
 
10/3/2013 276 1.4%
 
9/28/2016 236 1.2%
 
1/29/2016 215 1.1%
 
Other values (893) 10690 54.8%
 
Max length10
Mean length8.964355318
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Account_Name
Categorical

Distinct count1840
Unique (%)9.4%
Missing (%)0.0%
Missing (n)0
Account_Name_1888
 
2127
Account_Name_1836
 
886
Account_Name_25
 
873
Other values (1837)
15612
ValueCountFrequency (%) 
Account_Name_1888 2127 10.9%
 
Account_Name_1836 886 4.5%
 
Account_Name_25 873 4.5%
 
Account_Name_1991 609 3.1%
 
Account_Name_1642 397 2.0%
 
Account_Name_1508 365 1.9%
 
Account_Name_1440 318 1.6%
 
Account_Name_533 313 1.6%
 
Account_Name_263 270 1.4%
 
Account_Name_660 231 1.2%
 
Other values (1830) 13109 67.2%
 
Max length17
Mean length16.49825623
Min length14
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Account_Owner
Categorical

Distinct count48
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Person_Name_50
3795
Person_Name_8
 
1532
Person_Name_13
 
1497
Other values (45)
12674
ValueCountFrequency (%) 
Person_Name_50 3795 19.5%
 
Person_Name_8 1532 7.9%
 
Person_Name_13 1497 7.7%
 
Person_Name_43 1451 7.4%
 
Person_Name_18 1289 6.6%
 
Person_Name_3 966 5.0%
 
Person_Name_64 839 4.3%
 
Person_Name_4 747 3.8%
 
Person_Name_32 729 3.7%
 
Person_Name_65 719 3.7%
 
Other values (38) 5934 30.4%
 
Max length14
Mean length13.79310699
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Account_Type
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Account_Type_2
9989
Account_Type_0
6993
Account_Type_5
2200
Other values (4)
 
316
ValueCountFrequency (%) 
Account_Type_2 9989 51.2%
 
Account_Type_0 6993 35.9%
 
Account_Type_5 2200 11.3%
 
Account_Type_1 167 0.9%
 
None 113 0.6%
 
Account_Type_4 19 0.1%
 
Account_Type_6 17 0.1%
 
Max length14
Mean length13.94204534
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Actual_Delivery_Date
Constant

This variable is constant and should be ignored for analysis

Constant valueNaT

ASP
Numeric

Distinct count319
Unique (%)1.6%
Missing (%)16.9%
Missing (n)3293
Infinite (%)0.0%
Infinite (n)0
Mean6.328521031
Minimum0
Maximum80
Zeros (%)1.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.25
Q10.35
Median0.395
Q30.49
95-th percentile55
Maximum80
Range80
Interquartile range0.14

Descriptive statistics

Standard deviation17.79904956
Coef of variation2.812513298
Kurtosis6.369409575
Mean6.328521031
MAD10.63439147
Skewness2.811422481
Sum102553.6833
Variance316.8061651
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.38 847 4.3%
 
0.4 836 4.3%
 
0.36 762 3.9%
 
0.42 558 2.9%
 
0.39 498 2.6%
 
0.37 445 2.3%
 
0.35 328 1.7%
 
0.34 319 1.6%
 
0 316 1.6%
 
0.365 283 1.5%
 
Other values (308) 11013 56.5%
 
(Missing) 3293 16.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 316 1.6%
 
1e-05 1 < 0.1%
 
0.13 23 0.1%
 
0.15 56 0.3%
 
0.155 3 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
80 14 0.1%
 
78 86 0.4%
 
77 12 0.1%
 
76 6 < 0.1%
 
75 99 0.5%
 

ASP_(converted)
Numeric

Distinct count464
Unique (%)2.4%
Missing (%)16.9%
Missing (n)3293
Infinite (%)0.0%
Infinite (n)0
Mean0.4235557655
Minimum0
Maximum67
Zeros (%)1.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0.27
Q10.36
Median0.40154
Q30.46375
95-th percentile0.62
Maximum67
Range67
Interquartile range0.10375

Descriptive statistics

Standard deviation0.7679097921
Coef of variation1.81300753
Kurtosis5861.978161
Mean0.4235557655
MAD0.09128992887
Skewness74.73154913
Sum6863.72118
Variance0.5896854489
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
0.4 621 3.2%
 
0.38 610 3.1%
 
0.36 521 2.7%
 
0.39 355 1.8%
 
0.42 342 1.8%
 
0 315 1.6%
 
0.37 244 1.3%
 
0.40719 237 1.2%
 
0.42982 236 1.2%
 
0.47506 216 1.1%
 
Other values (453) 12508 64.2%
 
(Missing) 3293 16.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 315 1.6%
 
1e-05 1 < 0.1%
 
0.00378 1 < 0.1%
 
0.13 23 0.1%
 
0.15 56 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
67 1 < 0.1%
 
57.68578 1 < 0.1%
 
40.71938 1 < 0.1%
 
1.7 1 < 0.1%
 
1.6 6 < 0.1%
 

ASP_(converted)_Currency
Constant

This variable is constant and should be ignored for analysis

Constant valueUSD

ASP_Currency
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
USD
8908
EUR
5339
JPY
4690
Other values (2)
 
561
ValueCountFrequency (%) 
USD 8908 45.7%
 
EUR 5339 27.4%
 
JPY 4690 24.1%
 
AUD 556 2.9%
 
GBP 5 < 0.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Billing_Country
Categorical

Distinct count83
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
Japan
5080
United States
4800
Germany
2272
Other values (80)
7346
ValueCountFrequency (%) 
Japan 5080 26.1%
 
United States 4800 24.6%
 
Germany 2272 11.7%
 
Australia 1359 7.0%
 
India 752 3.9%
 
Netherlands 649 3.3%
 
France 537 2.8%
 
Singapore 526 2.7%
 
Spain 372 1.9%
 
Italy 367 1.9%
 
Other values (73) 2784 14.3%
 
Max length42
Mean length8.374243512
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Brand
Categorical

Distinct count28
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
None
18093
Other
 
877
Brand_9
 
153
Other values (25)
 
375
ValueCountFrequency (%) 
None 18093 92.8%
 
Other 877 4.5%
 
Brand_9 153 0.8%
 
Brand_5 65 0.3%
 
Brand_10 48 0.2%
 
Brand_24 43 0.2%
 
Brand_11 42 0.2%
 
Brand_13 29 0.1%
 
Brand_25 26 0.1%
 
Brand_22 24 0.1%
 
Other values (18) 98 0.5%
 
Max length8
Mean length4.140322084
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Bureaucratic_Code
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Bureaucratic_Code_4
14587
Bureaucratic_Code_5
4174
Bureaucratic_Code_2
 
351
Other values (4)
 
386
ValueCountFrequency (%) 
Bureaucratic_Code_4 14587 74.8%
 
Bureaucratic_Code_5 4174 21.4%
 
Bureaucratic_Code_2 351 1.8%
 
Bureaucratic_Code_1 303 1.6%
 
Bureaucratic_Code_0 80 0.4%
 
Bureaucratic_Code_3 2 < 0.1%
 
Bureaucratic_Code_6 1 < 0.1%
 
Max length19
Mean length19
Min length19
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Bureaucratic_Code_0_Approval
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
10416
1
9082
ValueCountFrequency (%) 
0 10416 53.4%
 
1 9082 46.6%
 

Bureaucratic_Code_0_Approved
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
13443
1
6055
ValueCountFrequency (%) 
0 13443 68.9%
 
1 6055 31.1%
 

Currency
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
18252
USD
 
631
EUR
 
615
ValueCountFrequency (%) 
None 18252 93.6%
 
USD 631 3.2%
 
EUR 615 3.2%
 
Max length4
Mean length3.93609601
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

Delivery_Quarter
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Q2
5511
Q1
5144
Q3
4455
ValueCountFrequency (%) 
Q2 5511 28.3%
 
Q1 5144 26.4%
 
Q3 4455 22.8%
 
Q4 4388 22.5%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Delivery_Terms
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Delivery_Terms_4
8808
Delivery_Terms_2
5446
Delivery_Terms_1
3355
Other values (6)
1889
ValueCountFrequency (%) 
Delivery_Terms_4 8808 45.2%
 
Delivery_Terms_2 5446 27.9%
 
Delivery_Terms_1 3355 17.2%
 
Delivery_Terms_6 928 4.8%
 
Delivery_Terms_5 689 3.5%
 
Delivery_Terms_8 172 0.9%
 
Delivery_Terms_7 49 0.3%
 
Delivery_Terms_3 42 0.2%
 
Delivery_Terms_0 9 < 0.1%
 
Max length16
Mean length16
Min length16
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Delivery_Year
Numeric

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2017.384911
Minimum2016
Maximum2020
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2016
5-th percentile2016
Q12017
Median2017
Q32018
95-th percentile2019
Maximum2020
Range4
Interquartile range1

Descriptive statistics

Standard deviation1.004535054
Coef of variation0.0004979392126
Kurtosis-0.9377144717
Mean2017.384911
MAD0.8703781513
Skewness0.1603412073
Sum39334971
Variance1.009090675
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=5)
ValueCountFrequency (%) 
2017 6318 32.4%
 
2018 5833 29.9%
 
2016 4371 22.4%
 
2019 2885 14.8%
 
2020 91 0.5%
 

Minimum 5 values

ValueCountFrequency (%) 
2016 4371 22.4%
 
2017 6318 32.4%
 
2018 5833 29.9%
 
2019 2885 14.8%
 
2020 91 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
2020 91 0.5%
 
2019 2885 14.8%
 
2018 5833 29.9%
 
2017 6318 32.4%
 
2016 4371 22.4%
 

df_index
Numeric

Distinct count16947
Unique (%)86.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean7531.25736
Minimum0
Maximum16946
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile487
Q12437
Median7197.5
Q312071.75
95-th percentile15971.15
Maximum16946
Range16946
Interquartile range9634.75

Descriptive statistics

Standard deviation5173.606874
Coef of variation0.6869512788
Kurtosis-1.290394422
Mean7531.25736
MAD4546.455735
Skewness0.1887020453
Sum146844456
Variance26766208.09
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 2550.5 16946. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 2 < 0.1%
 
345 2 < 0.1%
 
297 2 < 0.1%
 
2360 2 < 0.1%
 
313 2 < 0.1%
 
2376 2 < 0.1%
 
329 2 < 0.1%
 
2392 2 < 0.1%
 
2408 2 < 0.1%
 
2472 2 < 0.1%
 
Other values (16937) 19478 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 2 < 0.1%
 
1 2 < 0.1%
 
2 2 < 0.1%
 
3 2 < 0.1%
 
4 2 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
16946 1 < 0.1%
 
16945 1 < 0.1%
 
16944 1 < 0.1%
 
16943 1 < 0.1%
 
16942 1 < 0.1%
 

ID
Numeric

Distinct count19498
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean17130.37342
Minimum4854
Maximum28773
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum4854
5-th percentile6094.85
Q111227.25
Median17276.5
Q323191.75
95-th percentile27614.15
Maximum28773
Range23919
Interquartile range11964.5

Descriptive statistics

Standard deviation6912.570825
Coef of variation0.4035271535
Kurtosis-1.20040614
Mean17130.37342
MAD5988.423385
Skewness-0.0587571619
Sum334008021
Variance47783635.42
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 4854. 10222.5 21769.5 28773. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
6141 1 < 0.1%
 
17117 1 < 0.1%
 
21199 1 < 0.1%
 
10960 1 < 0.1%
 
15058 1 < 0.1%
 
13011 1 < 0.1%
 
6870 1 < 0.1%
 
27352 1 < 0.1%
 
25305 1 < 0.1%
 
23262 1 < 0.1%
 
Other values (19488) 19488 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
4854 1 < 0.1%
 
4856 1 < 0.1%
 
4858 1 < 0.1%
 
4859 1 < 0.1%
 
4860 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
28773 1 < 0.1%
 
28772 1 < 0.1%
 
28771 1 < 0.1%
 
28770 1 < 0.1%
 
28769 1 < 0.1%
 

Last_Activity
Constant

This variable is constant and should be ignored for analysis

Constant valueNaT

Last_Modified_By
Categorical

Distinct count63
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Person_Name_47
8519
Person_Name_50
 
1272
Person_Name_13
 
760
Other values (60)
8947
ValueCountFrequency (%) 
Person_Name_47 8519 43.7%
 
Person_Name_50 1272 6.5%
 
Person_Name_13 760 3.9%
 
Person_Name_8 743 3.8%
 
Person_Name_43 617 3.2%
 
Person_Name_18 571 2.9%
 
Person_Name_33 527 2.7%
 
Person_Name_3 475 2.4%
 
Person_Name_64 454 2.3%
 
Person_Name_19 420 2.2%
 
Other values (53) 5140 26.4%
 
Max length14
Mean length13.87885937
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Last_Modified_Date
Categorical

Distinct count751
Unique (%)3.9%
Missing (%)0.0%
Missing (n)0
2/8/2018
5821
12/4/2016
2673
9/6/2018
 
257
Other values (748)
10747
ValueCountFrequency (%) 
2/8/2018 5821 29.9%
 
12/4/2016 2673 13.7%
 
9/6/2018 257 1.3%
 
9/26/2018 206 1.1%
 
6/9/2018 187 1.0%
 
2/22/2017 173 0.9%
 
4/15/2019 161 0.8%
 
4/12/2019 116 0.6%
 
1/21/2016 116 0.6%
 
4/4/2019 115 0.6%
 
Other values (741) 9673 49.6%
 
Max length10
Mean length8.657246897
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Month
Categorical

Distinct count60
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
2018 - 10
 
666
2017 - 6
 
643
2017 - 10
 
638
Other values (57)
17551
ValueCountFrequency (%) 
2018 - 10 666 3.4%
 
2017 - 6 643 3.3%
 
2017 - 10 638 3.3%
 
2016 - 3 628 3.2%
 
2017 - 7 625 3.2%
 
2017 - 5 586 3.0%
 
2018 - 4 579 3.0%
 
2019 - 4 575 2.9%
 
2017 - 12 574 2.9%
 
2018 - 6 542 2.8%
 
Other values (50) 13442 68.9%
 
Max length9
Mean length8.225048723
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

Opportunity_Created_Date
Categorical

Distinct count1203
Unique (%)6.2%
Missing (%)0.0%
Missing (n)0
6/30/2017
 
124
1/22/2016
 
107
5/9/2017
 
104
Other values (1200)
19163
ValueCountFrequency (%) 
6/30/2017 124 0.6%
 
1/22/2016 107 0.5%
 
5/9/2017 104 0.5%
 
5/18/2016 99 0.5%
 
1/7/2016 89 0.5%
 
1/30/2018 87 0.4%
 
10/2/2017 86 0.4%
 
4/20/2017 83 0.4%
 
4/11/2019 83 0.4%
 
12/6/2017 82 0.4%
 
Other values (1193) 18554 95.2%
 
Max length10
Mean length8.920196943
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Opportunity_ID
Numeric

Distinct count11408
Unique (%)58.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6148.946507
Minimum0
Maximum12803
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile523
Q12892.25
Median6173
Q39072.75
95-th percentile12279.15
Maximum12803
Range12803
Interquartile range6180.5

Descriptive statistics

Standard deviation3745.879373
Coef of variation0.609190431
Kurtosis-1.128057847
Mean6148.946507
MAD3194.806174
Skewness0.1209435142
Sum119892159
Variance14031612.28
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000e+00 7.50000e+00 1.85000e+01 3.55000e+01 4.45000e+01 ... 1.27095e+04 1.27225e+04 1.27725e+04 1.27815e+04 1.28030e+04], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
12460 36 0.2%
 
2008 36 0.2%
 
12266 26 0.1%
 
5123 26 0.1%
 
6606 26 0.1%
 
2911 24 0.1%
 
10973 24 0.1%
 
767 18 0.1%
 
11089 18 0.1%
 
6652 16 0.1%
 
Other values (11398) 19248 98.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
12803 1 < 0.1%
 
12802 1 < 0.1%
 
12801 3 < 0.1%
 
12800 2 < 0.1%
 
12799 1 < 0.1%
 

Opportunity_Name
Categorical

Distinct count11408
Unique (%)58.5%
Missing (%)0.0%
Missing (n)0
Opportunity_Name_9795
 
36
Opportunity_Name_5036
 
36
Opportunity_Name_11461
 
26
Other values (11405)
19400
ValueCountFrequency (%) 
Opportunity_Name_9795 36 0.2%
 
Opportunity_Name_5036 36 0.2%
 
Opportunity_Name_11461 26 0.1%
 
Opportunity_Name_2922 26 0.1%
 
Opportunity_Name_12179 26 0.1%
 
Opportunity_Name_11879 24 0.1%
 
Opportunity_Name_6835 24 0.1%
 
Opportunity_Name_1661 18 0.1%
 
Opportunity_Name_10033 18 0.1%
 
Opportunity_Name_9628 16 0.1%
 
Other values (11398) 19248 98.7%
 
Max length22
Mean length21.15647759
Min length18
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Opportunity_Owner
Categorical

Distinct count58
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Person_Name_50
3845
Person_Name_8
 
1673
Person_Name_13
 
1415
Other values (55)
12565
ValueCountFrequency (%) 
Person_Name_50 3845 19.7%
 
Person_Name_8 1673 8.6%
 
Person_Name_13 1415 7.3%
 
Person_Name_18 1119 5.7%
 
Person_Name_43 937 4.8%
 
Person_Name_3 922 4.7%
 
Person_Name_64 771 4.0%
 
Person_Name_4 763 3.9%
 
Person_Name_32 740 3.8%
 
Person_Name_19 615 3.2%
 
Other values (48) 6698 34.4%
 
Max length14
Mean length13.80100523
Min length13
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Opportunity_Type
Categorical

Distinct count25
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Opportunity_Type_1
7916
Opportunity_Type_7
6411
Opportunity_Type_19
2076
Other values (22)
3095
ValueCountFrequency (%) 
Opportunity_Type_1 7916 40.6%
 
Opportunity_Type_7 6411 32.9%
 
Opportunity_Type_19 2076 10.6%
 
Opportunity_Type_8 1851 9.5%
 
Opportunity_Type_3 341 1.7%
 
Opportunity_Type_12 326 1.7%
 
Opportunity_Type_20 194 1.0%
 
Opportunity_Type_2 87 0.4%
 
Opportunity_Type_4 63 0.3%
 
Opportunity_Type_10 52 0.3%
 
Other values (15) 181 0.9%
 
Max length19
Mean length18.14134783
Min length18
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Planned_Delivery_End_Date
Categorical

Distinct count1214
Unique (%)6.2%
Missing (%)0.0%
Missing (n)0
3/31/2016
 
451
6/30/2017
 
322
2/29/2016
 
300
Other values (1211)
18425
ValueCountFrequency (%) 
3/31/2016 451 2.3%
 
6/30/2017 322 1.7%
 
2/29/2016 300 1.5%
 
9/28/2018 262 1.3%
 
6/29/2018 249 1.3%
 
6/30/2016 228 1.2%
 
9/30/2016 225 1.2%
 
12/31/2018 207 1.1%
 
3/31/2017 206 1.1%
 
12/31/2017 189 1.0%
 
Other values (1204) 16859 86.5%
 
Max length10
Mean length9.041491435
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Planned_Delivery_Start_Date
Categorical

Distinct count1193
Unique (%)6.1%
Missing (%)0.0%
Missing (n)0
3/31/2016
 
381
2/29/2016
 
273
10/1/2018
 
211
Other values (1190)
18633
ValueCountFrequency (%) 
3/31/2016 381 2.0%
 
2/29/2016 273 1.4%
 
10/1/2018 211 1.1%
 
4/2/2018 207 1.1%
 
4/1/2019 186 1.0%
 
7/2/2018 169 0.9%
 
2/1/2018 150 0.8%
 
6/1/2018 146 0.7%
 
3/1/2018 139 0.7%
 
10/2/2017 128 0.7%
 
Other values (1183) 17508 89.8%
 
Max length10
Mean length8.835572879
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Price
Categorical

Distinct count58
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
None
18175
Other
 
807
0.24
 
31
Other values (55)
 
485
ValueCountFrequency (%) 
None 18175 93.2%
 
Other 807 4.1%
 
0.24 31 0.2%
 
0.28 28 0.1%
 
0.27 24 0.1%
 
0.37 24 0.1%
 
0.41 24 0.1%
 
0.29 24 0.1%
 
0.32 21 0.1%
 
0.26 21 0.1%
 
Other values (48) 319 1.6%
 
Max length5
Mean length4.045543133
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Pricing,_Delivery_Terms_Approved
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
11241
0
8257
ValueCountFrequency (%) 
1 11241 57.7%
 
0 8257 42.3%
 

Pricing,_Delivery_Terms_Quote_Appr
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
15415
0
4083
ValueCountFrequency (%) 
1 15415 79.1%
 
0 4083 20.9%
 

Prod_Category_A
Constant

This variable is constant and should be ignored for analysis

Constant valueProd_Category_A_None

Product_Category_B
Categorical

Distinct count29
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
None
18118
Other
 
700
Product_Category_B_7
 
64
Other values (26)
 
616
ValueCountFrequency (%) 
None 18118 92.9%
 
Other 700 3.6%
 
Product_Category_B_7 64 0.3%
 
Product_Category_B_2 62 0.3%
 
Product_Category_B_11 57 0.3%
 
Product_Category_B_12 53 0.3%
 
Product_Category_B_5 48 0.2%
 
Product_Category_B_4 48 0.2%
 
Product_Category_B_24 33 0.2%
 
Product_Category_B_3 31 0.2%
 
Other values (19) 284 1.5%
 
Max length21
Mean length4.610780593
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Product_Family
Categorical

Distinct count247
Unique (%)1.3%
Missing (%)0.0%
Missing (n)0
Product_Family_133
 
1438
Product_Family_77
 
1345
Product_Family_132
 
894
Other values (244)
15821
ValueCountFrequency (%) 
Product_Family_133 1438 7.4%
 
Product_Family_77 1345 6.9%
 
Product_Family_132 894 4.6%
 
Product_Family_212 710 3.6%
 
Product_Family_100 630 3.2%
 
Product_Family_140 627 3.2%
 
Product_Family_85 598 3.1%
 
Product_Family_115 541 2.8%
 
Product_Family_226 524 2.7%
 
Product_Family_208 509 2.6%
 
Other values (237) 11682 59.9%
 
Max length18
Mean length17.68622423
Min length16
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Product_Name
Categorical

Distinct count506
Unique (%)2.6%
Missing (%)0.0%
Missing (n)0
Product_Name_100
 
976
Product_Name_226
 
950
Product_Name_231
 
670
Other values (503)
16902
ValueCountFrequency (%) 
Product_Name_100 976 5.0%
 
Product_Name_226 950 4.9%
 
Product_Name_231 670 3.4%
 
Product_Name_491 524 2.7%
 
Product_Name_241 518 2.7%
 
Product_Name_4 474 2.4%
 
Product_Name_192 443 2.3%
 
Product_Name_132 394 2.0%
 
Product_Name_111 390 2.0%
 
Product_Name_29 389 2.0%
 
Other values (496) 13770 70.6%
 
Max length16
Mean length15.77546415
Min length14
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Product_Type
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
18122
Other
 
673
Product_Type_1
 
255
Other values (4)
 
448
ValueCountFrequency (%) 
None 18122 92.9%
 
Other 673 3.5%
 
Product_Type_1 255 1.3%
 
Product_Type_3 204 1.0%
 
Product_Type_0 122 0.6%
 
Product_Type_4 107 0.5%
 
Product_Type_2 15 0.1%
 
Max length14
Mean length4.395066161
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Quote_Expiry_Date
Categorical

Distinct count1124
Unique (%)5.8%
Missing (%)0.0%
Missing (n)0
NaT
5861
6/30/2017
 
436
3/31/2017
 
363
Other values (1121)
12838
ValueCountFrequency (%) 
NaT 5861 30.1%
 
6/30/2017 436 2.2%
 
3/31/2017 363 1.9%
 
9/30/2017 225 1.2%
 
12/31/2016 200 1.0%
 
10/31/2017 171 0.9%
 
1/31/2018 163 0.8%
 
11/30/2017 156 0.8%
 
12/31/2017 156 0.8%
 
5/31/2017 153 0.8%
 
Other values (1114) 11614 59.6%
 
Max length10
Mean length7.250538517
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Quote_Type
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Non Binding
19328
Binding
 
170
ValueCountFrequency (%) 
Non Binding 19328 99.1%
 
Binding 170 0.9%
 
Max length11
Mean length10.96512463
Min length7
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Region
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
EMEA
5502
Japan
5093
Americas
4961
Other values (2)
3942
ValueCountFrequency (%) 
EMEA 5502 28.2%
 
Japan 5093 26.1%
 
Americas 4961 25.4%
 
APAC 3744 19.2%
 
Middle East 198 1.0%
 
Max length11
Mean length5.350035901
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Sales_Contract_No
Categorical

Distinct count6065
Unique (%)31.1%
Missing (%)0.0%
Missing (n)0
None
8186
479
 
36
108
 
36
Other values (6062)
11240
ValueCountFrequency (%) 
None 8186 42.0%
 
479 36 0.2%
 
108 36 0.2%
 
5849 24 0.1%
 
2575 18 0.1%
 
3123 16 0.1%
 
3878 16 0.1%
 
3876 16 0.1%
 
3877 16 0.1%
 
3980 16 0.1%
 
Other values (6055) 11118 57.0%
 
Max length4
Mean length3.891681198
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Size
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
None
18157
Size_3
 
531
Other
 
478
Other values (4)
 
332
ValueCountFrequency (%) 
None 18157 93.1%
 
Size_3 531 2.7%
 
Other 478 2.5%
 
Size_4 283 1.5%
 
Size_1 30 0.2%
 
Size_0 17 0.1%
 
Size_2 2 < 0.1%
 
Max length6
Mean length4.113037235
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Source_
Categorical

Distinct count14
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
None
10612
Source_7
3666
Source_9
 
1771
Other values (11)
3449
ValueCountFrequency (%) 
None 10612 54.4%
 
Source_7 3666 18.8%
 
Source_9 1771 9.1%
 
Source_11 1625 8.3%
 
Source_13 911 4.7%
 
Source_3 458 2.3%
 
Source_1 148 0.8%
 
Source_10 127 0.7%
 
Source_2 99 0.5%
 
Source_4 45 0.2%
 
Other values (4) 36 0.2%
 
Max length9
Mean length5.959636886
Min length4
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Stage
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.3%
Missing (n)64
1
9533
0
7350
-1
2551
(Missing)
 
64
ValueCountFrequency (%) 
1 9533 48.9%
 
0 7350 37.7%
 
-1 2551 13.1%
 
(Missing) 64 0.3%
 
Max length4
Mean length3.130833932
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

Submitted_for_Approval
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
19484
1
 
14
ValueCountFrequency (%) 
0 19484 99.9%
 
1 14 0.1%
 

Territory
Categorical

Distinct count79
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
None
5180
NW America
 
1995
Germany
 
1955
Other values (76)
10368
ValueCountFrequency (%) 
None 5180 26.6%
 
NW America 1995 10.2%
 
Germany 1955 10.0%
 
Australia 1416 7.3%
 
NE America 939 4.8%
 
India 915 4.7%
 
Japan 766 3.9%
 
Netherlands 629 3.2%
 
SE America 601 3.1%
 
France 584 3.0%
 
Other values (69) 4518 23.2%
 
Max length20
Mean length7.170427736
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Total_Amount
Numeric

Distinct count10246
Unique (%)52.5%
Missing (%)0.3%
Missing (n)59
Infinite (%)0.0%
Infinite (n)0
Mean1969405.111
Minimum0
Maximum1320000000
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile2963.22
Q129925
Median107590
Q3431585.6
95-th percentile6720481.026
Maximum1320000000
Range1320000000
Interquartile range401660.6

Descriptive statistics

Standard deviation18108757.87
Coef of variation9.195039538
Kurtosis2236.42959
Mean1969405.111
MAD3069151.633
Skewness40.71457842
Sum3.828326596e+10
Variance3.279271115e+14
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
6200 513 2.6%
 
4400 461 2.4%
 
18000 356 1.8%
 
140000 272 1.4%
 
1600 204 1.0%
 
160000 132 0.7%
 
109620 100 0.5%
 
23400 80 0.4%
 
85260 75 0.4%
 
81200 75 0.4%
 
Other values (10235) 17171 88.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 52 0.3%
 
0.01 7 < 0.1%
 
0.02 3 < 0.1%
 
0.04 1 < 0.1%
 
0.1 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1320000000 1 < 0.1%
 
919992410 1 < 0.1%
 
760000000 1 < 0.1%
 
660005280 1 < 0.1%
 
660004620 1 < 0.1%
 

Total_Amount_Currency
Recoded

This variable is a recoding of ASP_Currency and should be ignored for analysis

Total_Taxable_Amount
Numeric

Distinct count8268
Unique (%)42.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3246258.588
Minimum0
Maximum1356338620
Zeros (%)5.6%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q184000
Median356475
Q31010300
95-th percentile12643366.05
Maximum1356338620
Range1356338620
Interquartile range926300

Descriptive statistics

Standard deviation20870305.74
Coef of variation6.429033661
Kurtosis1437.812404
Mean3246258.588
MAD4829295.512
Skewness30.86984245
Sum6.329554995e+10
Variance4.355696616e+14
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.00000000e+00 7.50000000e-02 1.00750000e+02 1.48315000e+02 2.47031500e+03 ... 1.02197399e+08 1.11352244e+08 1.14540404e+08 2.18685000e+08 1.35633862e+09], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 1090 5.6%
 
588325 72 0.4%
 
109620 68 0.3%
 
488700 66 0.3%
 
413700 60 0.3%
 
552400 60 0.3%
 
1767640 48 0.2%
 
523100 40 0.2%
 
105840 37 0.2%
 
148331.25 36 0.2%
 
Other values (8258) 17921 91.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1090 5.6%
 
0.15 1 < 0.1%
 
45 1 < 0.1%
 
78.18 1 < 0.1%
 
100.1 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1356338620 1 < 0.1%
 
919992410 1 < 0.1%
 
760000000 1 < 0.1%
 
680872500 1 < 0.1%
 
660005280 1 < 0.1%
 

Total_Taxable_Amount_Currency
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
USD
8891
EUR
5354
JPY
4696
Other values (2)
 
557
ValueCountFrequency (%) 
USD 8891 45.6%
 
EUR 5354 27.5%
 
JPY 4696 24.1%
 
AUD 553 2.8%
 
GBP 4 < 0.1%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

TRF
Numeric

Distinct count107
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2.354959483
Minimum0
Maximum1272
Zeros (%)70.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q31
95-th percentile10
Maximum1272
Range1272
Interquartile range1

Descriptive statistics

Standard deviation15.45445392
Coef of variation6.562513721
Kurtosis2560.05356
Mean2.354959483
MAD3.703936548
Skewness38.14278497
Sum45917
Variance238.8401459
Memory size152.5 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 3.500e+00 ... 6.850e+01 1.265e+02 1.875e+02 5.010e+02 1.272e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 13677 70.1%
 
1 2688 13.8%
 
2 729 3.7%
 
3 397 2.0%
 
5 330 1.7%
 
4 244 1.3%
 
10 201 1.0%
 
6 148 0.8%
 
7 116 0.6%
 
20 89 0.5%
 
Other values (97) 879 4.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 13677 70.1%
 
1 2688 13.8%
 
2 729 3.7%
 
3 397 2.0%
 
4 244 1.3%
 

Maximum 5 values

ValueCountFrequency (%) 
1272 1 < 0.1%
 
502 1 < 0.1%
 
500 1 < 0.1%
 
429 1 < 0.1%
 
400 2 < 0.1%
 

Correlations

Missing values

Sample

First rows

Account_Created_DateAccount_NameAccount_OwnerAccount_TypeActual_Delivery_DateASPASP_(converted)ASP_(converted)_CurrencyASP_CurrencyBilling_CountryBrandBureaucratic_CodeBureaucratic_Code_0_ApprovalBureaucratic_Code_0_ApprovedCurrencyDelivery_QuarterDelivery_TermsDelivery_Yeardf_indexIDLast_ActivityLast_Modified_ByLast_Modified_DateMonthOpportunity_Created_DateOpportunity_IDOpportunity_NameOpportunity_OwnerOpportunity_TypePlanned_Delivery_End_DatePlanned_Delivery_Start_DatePricePricing,_Delivery_Terms_ApprovedPricing,_Delivery_Terms_Quote_ApprProd_Category_AProduct_Category_BProduct_FamilyProduct_NameProduct_TypeQuote_Expiry_DateQuote_TypeRegionSales_Contract_NoSizeSource_StageSubmitted_for_ApprovalTerritoryTotal_AmountTotal_Amount_CurrencyTotal_Taxable_AmountTotal_Taxable_Amount_CurrencyTRF
06/16/2015Account_Name_619Person_Name_51Account_Type_2NaT0.520.58817USDEURNetherlandsNoneBureaucratic_Code_411NoneQ2Delivery_Terms_22016027761NaTPerson_Name_186/13/20162016 - 512/7/20150Opportunity_Name_12598Person_Name_18Opportunity_Type_16/30/20165/1/2016None11Prod_Category_A_NoneNoneProduct_Family_77Product_Name_99None1/30/2016Non BindingEMEANoneNoneNone0.00None5272800.0EUR5272800.0EUR10
16/16/2015Account_Name_619Person_Name_51Account_Type_2NaT0.530.59948USDEURNetherlandsNoneBureaucratic_Code_400NoneQ1Delivery_Terms_22016127760NaTPerson_Name_201/15/20162016 - 112/7/20151Opportunity_Name_12600Person_Name_20Opportunity_Type_11/20/20161/18/2016None00Prod_Category_A_NoneNoneProduct_Family_77Product_Name_100None1/20/2016Non BindingEMEA39NoneNone1.00None48230.0EUR48230.0EUR0
24/21/2015Account_Name_1794Person_Name_64Account_Type_5NaT0.480.48000USDUSDUnited StatesNoneBureaucratic_Code_400NoneQ1Delivery_Terms_42016227446NaTPerson_Name_89/29/20162016 - 112/8/20152Opportunity_Name_469Person_Name_8Opportunity_Type_11/25/20161/25/2016None00Prod_Category_A_NoneNoneProduct_Family_81Product_Name_91None9/30/2016Non BindingAmericas760NoneSource_71.00NW America83865.6USD83865.6USD0
37/27/2013Account_Name_1201Person_Name_8Account_Type_5NaT0.530.53000USDUSDUnited StatesOtherBureaucratic_Code_510USDQ1Delivery_Terms_12018316808NaTPerson_Name_83/27/20182018 - 212/8/20153Opportunity_Name_415Person_Name_8Opportunity_Type_193/31/20182/1/20180.4201Prod_Category_A_NoneProduct_Category_B_16Product_Family_209Product_Name_432Product_Type_0NaTNon BindingAmericasNoneSize_4Source_110.00NW America7421881.5USD7421881.5USD14
47/27/2013Account_Name_1201Person_Name_8Account_Type_5NaT0.530.53000USDUSDUnited StatesOtherBureaucratic_Code_510USDQ1Delivery_Terms_12018416805NaTPerson_Name_83/27/20182018 - 212/8/20154Opportunity_Name_851Person_Name_8Opportunity_Type_192/28/20182/1/20180.4201Prod_Category_A_NoneProduct_Category_B_16Product_Family_209Product_Name_432Product_Type_06/2/2017Non BindingAmericasNoneSize_4Source_110.00NW America13357192.5USD13357192.5USD25
57/27/2013Account_Name_1201Person_Name_8Account_Type_5NaT0.530.53000USDUSDUnited StatesOtherBureaucratic_Code_510USDQ1Delivery_Terms_12018516802NaTPerson_Name_83/27/20182018 - 212/8/20155Opportunity_Name_939Person_Name_8Opportunity_Type_193/31/20182/1/20180.4201Prod_Category_A_NoneProduct_Category_B_16Product_Family_209Product_Name_432Product_Type_06/2/2017Non BindingAmericasNoneSize_4Source_110.00NW America14838277.5USD14838277.5USD28
67/27/2013Account_Name_1201Person_Name_8Account_Type_5NaT0.380.38000USDUSDUnited StatesNoneBureaucratic_Code_510NoneQ1Delivery_Terms_42017616799NaTPerson_Name_810/7/20162017 - 212/8/20156Opportunity_Name_1618Person_Name_8Opportunity_Type_195/1/20172/1/2017None01Prod_Category_A_NoneNoneProduct_Family_164Product_Name_308NoneNaTNon BindingAmericasNoneNoneSource_110.00NW America2659494.6USD2659494.6USD7
74/21/2015Account_Name_1794Person_Name_64Account_Type_5NaT0.480.48000USDUSDUnited StatesNoneBureaucratic_Code_411NoneQ1Delivery_Terms_42016727455NaTPerson_Name_812/9/20152016 - 112/9/20157Opportunity_Name_8227Person_Name_8Opportunity_Type_11/25/20161/25/2016None11Prod_Category_A_NoneNoneProduct_Family_143Product_Name_251None1/7/2016Non BindingAmericasNoneNoneSource_71.00NW America50688.0USD50688.0USD0
84/20/2015Account_Name_1888Person_Name_50Account_Type_2NaTNaNNaNUSDJPYJapanNoneBureaucratic_Code_500NoneQ1Delivery_Terms_42016824353NaTPerson_Name_504/5/20162016 - 212/9/20158Opportunity_Name_6151Person_Name_50Opportunity_Type_72/29/20162/29/2016None01Prod_Category_A_NoneNoneProduct_Family_6Product_Name_6NoneNaTNon BindingJapanNoneNoneNone0.00None15600.0JPY470400.0JPY0
94/20/2015Account_Name_1888Person_Name_50Account_Type_2NaTNaNNaNUSDJPYJapanNoneBureaucratic_Code_500NoneQ1Delivery_Terms_42016924355NaTPerson_Name_504/5/20162016 - 212/9/20158Opportunity_Name_6151Person_Name_50Opportunity_Type_72/29/20162/29/2016None01Prod_Category_A_NoneNoneProduct_Family_4Product_Name_4NoneNaTNon BindingJapanNoneNoneNone0.00None4400.0JPY470400.0JPY0

Last rows

Account_Created_DateAccount_NameAccount_OwnerAccount_TypeActual_Delivery_DateASPASP_(converted)ASP_(converted)_CurrencyASP_CurrencyBilling_CountryBrandBureaucratic_CodeBureaucratic_Code_0_ApprovalBureaucratic_Code_0_ApprovedCurrencyDelivery_QuarterDelivery_TermsDelivery_Yeardf_indexIDLast_ActivityLast_Modified_ByLast_Modified_DateMonthOpportunity_Created_DateOpportunity_IDOpportunity_NameOpportunity_OwnerOpportunity_TypePlanned_Delivery_End_DatePlanned_Delivery_Start_DatePricePricing,_Delivery_Terms_ApprovedPricing,_Delivery_Terms_Quote_ApprProd_Category_AProduct_Category_BProduct_FamilyProduct_NameProduct_TypeQuote_Expiry_DateQuote_TypeRegionSales_Contract_NoSizeSource_StageSubmitted_for_ApprovalTerritoryTotal_AmountTotal_Amount_CurrencyTotal_Taxable_AmountTotal_Taxable_Amount_CurrencyTRF
194884/19/2018Account_Name_1379Person_Name_13Account_Type_0NaT0.270.30540USDEURNorwayNoneBureaucratic_Code_210NoneQ2Delivery_Terms_72019254114091NaTPerson_Name_134/25/20192019 - 54/25/201912360Opportunity_Name_9792Person_Name_13Opportunity_Type_75/17/20195/13/2019None11Prod_Category_A_NoneNoneProduct_Family_140Product_Name_241NoneNaTNon BindingEMEANoneNoneSource_9-1.01Norway28992.6EUR74834.55EUR0
194896/30/2017Account_Name_1542Person_Name_50Account_Type_5NaT44.000.39558USDJPYJapanNoneBureaucratic_Code_400NoneQ3Delivery_Terms_4201925425817NaTPerson_Name_14/26/20192019 - 74/26/201912361Opportunity_Name_7265Person_Name_55Opportunity_Type_17/1/20197/1/2019None11Prod_Category_A_NoneNoneProduct_Family_168Product_Name_322NoneNaTNon BindingJapanNoneNoneNone-1.00Japan5068800.0JPY5068800.00JPY0
194902/12/2019Account_Name_1377Person_Name_55Account_Type_0NaT38.000.34163USDJPYJapanNoneBureaucratic_Code_400NoneQ4Delivery_Terms_42019254311318NaTPerson_Name_554/26/20192019 - 104/26/201912362Opportunity_Name_11565Person_Name_55Opportunity_Type_110/1/201910/1/2019None11Prod_Category_A_NoneNoneProduct_Family_154Product_Name_276NoneNaTNon BindingJapan6506NoneNone-1.00None20282500.0JPY20282500.00JPY1
194916/17/2015Account_Name_628Person_Name_18Account_Type_2NaT0.300.33933USDEURBelgiumNoneBureaucratic_Code_411NoneQ3Delivery_Terms_22019254427867NaTPerson_Name_234/26/20192019 - 74/26/201912363Opportunity_Name_4638Person_Name_18Opportunity_Type_17/19/20197/1/2019None11Prod_Category_A_NoneNoneProduct_Family_160Product_Name_290None5/24/2019Non BindingEMEANoneNoneSource_7-1.00Belgium227292.0EUR227292.00EUR1
194926/12/2017Account_Name_1686Person_Name_13Account_Type_0NaT0.300.30000USDUSDSouth AfricaNoneBureaucratic_Code_400NoneQ2Delivery_Terms_72019254516339NaTPerson_Name_134/26/20192019 - 54/26/201912364Opportunity_Name_11120Person_Name_13Opportunity_Type_15/10/20195/1/2019None11Prod_Category_A_NoneNoneProduct_Family_140Product_Name_241None5/24/2019Non BindingEMEA6508NoneSource_3-1.00KSA23010.0USD147750.00USD0
194936/12/2017Account_Name_1686Person_Name_13Account_Type_0NaT0.300.30000USDUSDSouth AfricaNoneBureaucratic_Code_400NoneQ2Delivery_Terms_72019254616345NaTPerson_Name_134/26/20192019 - 54/26/201912364Opportunity_Name_11120Person_Name_13Opportunity_Type_15/10/20195/1/2019None11Prod_Category_A_NoneNoneProduct_Family_213Product_Name_447None5/24/2019Non BindingEMEA6508NoneSource_3-1.00KSA124740.0USD147750.00USD0
194946/8/2018Account_Name_768Person_Name_38Account_Type_2NaT0.410.41000USDUSDUnited StatesNoneBureaucratic_Code_400NoneQ4Delivery_Terms_42019254715218NaTPerson_Name_384/27/20192019 - 104/26/201912365Opportunity_Name_9694Person_Name_38Opportunity_Type_112/31/201910/1/2019None11Prod_Category_A_NoneNoneProduct_Family_221Product_Name_477None5/24/2019Non BindingAmericas6510NoneNone-1.00SE America45054.9USD45054.90USD0
194956/8/2018Account_Name_768Person_Name_38Account_Type_2NaT0.410.41000USDUSDUnited StatesNoneBureaucratic_Code_411NoneQ4Delivery_Terms_42019254815224NaTPerson_Name_384/27/20192019 - 104/26/201912366Opportunity_Name_9693Person_Name_38Opportunity_Type_112/31/201910/1/2019None11Prod_Category_A_NoneNoneProduct_Family_221Product_Name_477None5/24/2019Non BindingAmericas6511NoneNone-1.00SE America100122.0USD100122.00USD0
194968/29/2018Account_Name_1635Person_Name_9Account_Type_2NaT0.500.50000USDUSDUnited StatesNoneBureaucratic_Code_400NoneQ3Delivery_Terms_4201925497286NaTPerson_Name_94/26/20192019 - 84/26/201912367Opportunity_Name_1676Person_Name_9Opportunity_Type_78/1/20198/1/2019None11Prod_Category_A_NoneNoneProduct_Family_156Product_Name_281None5/26/2019Non BindingAmericasNoneNoneNone-1.00NE America143220.0USD143220.00USD0
194973/3/2016Account_Name_271Person_Name_18Account_Type_0NaT0.290.32802USDEURLuxembourgNoneBureaucratic_Code_500NoneQ4Delivery_Terms_22019255011263NaTPerson_Name_164/27/20192019 - 104/27/201912368Opportunity_Name_3187Person_Name_16Opportunity_Type_112/13/201910/21/2019None01Prod_Category_A_NoneNoneProduct_Family_171Product_Name_331None2/8/2019Non BindingEMEANoneNoneNone-1.00Belgium871020.8EUR871020.80EUR3